﻿create database TaskDb
go

use TaskDb

go
create table Users
(
	Id int primary key identity not null,
	Username nvarchar(80) not null,
	Password nvarchar(80) not null,
	IsActived bit not null default 1,
	Isdeleted bit not null default 0,
	Createtime datetime not null default getdate(),
	Updatedtime datetime not null default getdate(),
	Remarks nvarchar(800) null
)

go

create table Task
(
	Id int primary key identity not null,
	TaskName nvarchar(80) not null,
	TaskContent nvarchar(800) not null,
	TaskStatus nvarchar(800) not null default 'ִ',
	CreatedUserId int not null,
	IsActived bit not null default 1,
	Isdeleted bit not null default 0,
	Createtime datetime not null default getdate(),
	Updatedtime datetime not null default getdate(),
	Remarks nvarchar(800) null
)

go


insert into Users(Username,Password) values ('admin','113'),('user01','113')

go

insert into Task (TaskName,TaskContent,CreatedUserId) values ('1','猎猴',1)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('2','猎猴',1)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('3','猎猴',1)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('4','猎猴',1)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('5','猎猴',2)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('6','猎猴',1)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('7','猎猴',1)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('8','猎猴',2)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('9','猎猴',2)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('10','猎猴',2)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('11','猎猴',1)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('12','猎猴',1)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('13','猎猴',1)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('14','猎猴',1)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('15','猎猴',1)
insert into Task (TaskName,TaskContent,CreatedUserId) values ('16','猎猴',1)
go


select * from Users
select * from Task


